Installation Note 41537: SAS® Risk Reporting Repository 1.3 Data Dictionary has incorrect descriptions for PROJECT_DIM columns: BASE_DT, VAL_DT, and PROJECT_OPTION_SET_SK
SAS® Risk Reporting Repository 1.3 Data Dictionary has incorrect descriptions listed in the comment column for the following variables of the PROJECT_DIM table: BASE_DT, VAL_DT, and PROJECT_OPTION_SET_SK. See the tables below for corrected descriptions.
| BASE_DT |
Comment currently reads: Date stamp for the risk dimensions rundate value
for the result set in the model. |
| Comment should read: Intended for the date stamp for the portfolio and current market situation date. This is used as the base case date of the analysis project. It is the situation snapshot date.
|
| VAL_DT |
Comment currently reads: Date stamp for the risk dimensions rundate value
for the result set in the model. |
| Comment should read: Date stamp for the date value for when the analysis
project is executed. This value does not have to be the same as the BASE_DT. For example, the analysis project can be executed on January 1, 2010 (VAL_DT) for a situation snapshot of December 1, 2009 (BASE_DT).
|
| PROJECT_OPTION_SET_SK |
Comment currently reads: Because source data for PROJECT_DIM might come from
multiple systems, the business supplied keys might not be unique. A surrogate key is added in the
ETL process to ensure a unique identifier for PROJECT_DIM. Used with valid_from_dttm for versioning of rows. |
| Comment should read: A surrogate key of a given set of options used by
projects. These options are characteristics of a project that may be shared.
|
Operating System and Release Information
| SAS System | SAS Risk Reporting Repository | Linux | 1.3 | 1.4 | | 9.2 TS2M0 |
| HP-UX IPF | 1.3 | 1.4 | | 9.2 TS2M0 |
| Linux for x64 | 1.3 | 1.4 | | 9.2 TS2M0 |
| 64-bit Enabled Solaris | 1.3 | 1.4 | | 9.2 TS2M0 |
| 64-bit Enabled HP-UX | 1.3 | 1.4 | | 9.2 TS2M0 |
| 64-bit Enabled AIX | 1.3 | 1.4 | | 9.2 TS2M0 |
| Windows Vista for x64 | 1.3 | 1.4 | | 9.2 TS2M0 |
| Windows Vista | 1.3 | 1.4 | | 9.2 TS2M0 |
| Windows Millennium Edition (Me) | 1.3 | | | |
| Windows 7 Professional 32 bit | 1.3 | | | |
| Windows 7 Enterprise x64 | 1.3 | | | |
| Windows 7 Enterprise 32 bit | 1.3 | | | |
| Microsoft Windows XP Professional | 1.3 | 1.4 | | 9.2 TS2M0 |
| Microsoft Windows Server 2008 for x64 | 1.3 | 1.4 | | 9.2 TS2M0 |
| Microsoft Windows Server 2008 | 1.3 | | | |
| Microsoft Windows Server 2003 for x64 | 1.3 | 1.4 | | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Standard Edition | 1.3 | 1.4 | | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 1.3 | 1.4 | | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 1.3 | 1.4 | | 9.2 TS2M0 |
| Microsoft Windows NT Workstation | 1.3 | | | |
| Microsoft Windows 2000 Professional | 1.3 | | | |
| Microsoft Windows 2000 Server | 1.3 | | | |
| Microsoft Windows 2000 Advanced Server | 1.3 | | | |
| Microsoft Windows 95/98 | 1.3 | | | |
| Windows 7 Ultimate x64 | 1.3 | | | |
| Windows 7 Ultimate 32 bit | 1.3 | | | |
| Windows 7 Professional x64 | 1.3 | | | |
| Windows 7 Home Premium x64 | 1.3 | | | |
| Windows 7 Home Premium 32 bit | 1.3 | | | |
| Microsoft Windows 2000 Datacenter Server | 1.3 | | | |
| Microsoft® Windows® for x64 | 1.3 | 1.4 | | 9.2 TS2M0 |
| Solaris for x64 | 1.3 | 1.4 | | 9.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Installation Note |
| Priority: | medium |
| Date Modified: | 2010-11-15 12:50:13 |
| Date Created: | 2010-11-09 14:42:42 |
